/* rpbr001.p - PL Resource Bills Browse UI                                  */
/* Copyright 1986-2002 QAD Inc., Carpinteria, CA, USA.                      */
/* All rights reserved worldwide.  This is an unpublished work.             */
/* $Revision: 1.9 $    */
/*V8:ConvertMode=NoConvert                                                  */
/********************************** History *********************************
 *    Revision: 8.5      Created: 06/19/97    By: B. Pedersen    *J1TF*
 *    Revision: 8.5     Modified: 09/26/97    By: B. Pedersen    *J20C*
 *    Revision: 8.5     Modified: 01/31/99    By: Doug Norton    *M071*
 *    Revision: 9.0     Modified: 03/15/99    By: Mark Smith     *M0BF*
 *    Revision: 9.1     Modified: 08/15/00    By: Mark Brown     *N0KP*
 * $Revision: 1.9 $    BY: Jean Miller          DATE: 04/05/02  ECO: *P044*
 ****************************************************************************/

{mfdeclre.i}

&SCOPED-DEFINE BR-TITLE "PL Resource Bills"

&SCOPED-DEFINE BR-NAME rp001
&SCOPED-DEFINE Q-DRAG-BACK-COL 1

&SCOPED-DEFINE Q-FIRST-TABLE pq_mstr
&SCOPED-DEFINE Q-FIRST-FIELD-LIST (pq_prod_line pq_site pq_rsc pq_qty_per pq_lead pq_lt_off pq_start pq_end)
&SCOPED-DEFINE Q-2ND-TABLE rs_mstr
&SCOPED-DEFINE Q-2ND-JOIN rs_rsc = pq_rsc
&SCOPED-DEFINE Q-2ND-FIELD-LIST (rs_um)
&SCOPED-DEFINE Q-NUM-TABLES 2

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-1 b-1.pq_prod_line
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-1 pq_mstr.pq_prod_line
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-1 tt-pq_prod_line
&SCOPED-DEFINE BR-K-COL-LABEL-1 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-1 "Line"
&SCOPED-DEFINE BR-FIELD-TYPE-1 character
&SCOPED-DEFINE BR-FIELD-FRMT-1 FORMAT "x(4)"
&SCOPED-DEFINE BR-FIELD-WIDTH-1 5

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-2 b-1.pq_site
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-2 pq_mstr.pq_site
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-2 tt-pq_site
&SCOPED-DEFINE BR-K-COL-LABEL-2 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-2 "Site"
&SCOPED-DEFINE BR-FIELD-TYPE-2 character
&SCOPED-DEFINE BR-FIELD-FRMT-2 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-2 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-3 b-1.pq_rsc
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-3 pq_mstr.pq_rsc
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-3 tt-pq_rsc
&SCOPED-DEFINE BR-K-COL-LABEL-3 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-3 "Resource"
&SCOPED-DEFINE BR-FIELD-TYPE-3 character
&SCOPED-DEFINE BR-FIELD-FRMT-3 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-3 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-4 b-1.pq_qty_per
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-4 pq_mstr.pq_qty_per
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-4 tt-pq_qty_per
&SCOPED-DEFINE BR-K-COL-LABEL-4 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-4 "Quantity Per"
&SCOPED-DEFINE BR-FIELD-TYPE-4 decimal
&SCOPED-DEFINE BR-FIELD-FRMT-4 FORMAT "->>>>,>>9.9<<<<<<<"
&SCOPED-DEFINE BR-FIELD-WIDTH-4 19

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-5 b-2.rs_um
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-5 rs_mstr.rs_um
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-5 tt-rs_um
&SCOPED-DEFINE BR-K-COL-LABEL-5 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-5 "UM"
&SCOPED-DEFINE BR-FIELD-TYPE-5 character
&SCOPED-DEFINE BR-FIELD-FRMT-5 FORMAT "x(2)"
&SCOPED-DEFINE BR-FIELD-WIDTH-5 3

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-6 b-1.pq_lead
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-6 pq_mstr.pq_lead
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-6 tt-pq_lead
&SCOPED-DEFINE BR-K-COL-LABEL-6 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-6 "LTM"
&SCOPED-DEFINE BR-FIELD-TYPE-6 integer
&SCOPED-DEFINE BR-FIELD-FRMT-6 FORMAT ">>9"
&SCOPED-DEFINE BR-FIELD-WIDTH-6 4

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-7 b-1.pq_lt_off
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-7 pq_mstr.pq_lt_off
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-7 tt-pq_lt_off
&SCOPED-DEFINE BR-K-COL-LABEL-7 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-7 "LTO"
&SCOPED-DEFINE BR-FIELD-TYPE-7 integer
&SCOPED-DEFINE BR-FIELD-FRMT-7 FORMAT "->>9"
&SCOPED-DEFINE BR-FIELD-WIDTH-7 5

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-8 b-1.pq_start
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-8 pq_mstr.pq_start
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-8 tt-pq_start
&SCOPED-DEFINE BR-K-COL-LABEL-8 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-8 "Start Date"
&SCOPED-DEFINE BR-FIELD-TYPE-8 date
&SCOPED-DEFINE BR-FIELD-FRMT-8 FORMAT "99/99/99"
&SCOPED-DEFINE BR-FIELD-WIDTH-8 11

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-9 b-1.pq_end
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-9 pq_mstr.pq_end
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-9 tt-pq_end
&SCOPED-DEFINE BR-K-COL-LABEL-9 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-9 "End Date"
&SCOPED-DEFINE BR-FIELD-TYPE-9 date
&SCOPED-DEFINE BR-FIELD-FRMT-9 FORMAT "99/99/99"
&SCOPED-DEFINE BR-FIELD-WIDTH-9 9

&SCOPED-DEFINE Q-NUM-FILT-VALS 9
&SCOPED-DEFINE BR-MAX-FIELD-WIDTH 19
&SCOPED-DEFINE BR-BROWSE-WIDTH 74
&SCOPED-DEFINE WHERE-CLAUSE
&SCOPED-DEFINE BR-INDEXED-FIELDS 1,3

{wbbr01.i}
if c-application-mode <> 'WEB' then do:
   {browse.i}
end.
